﻿using System;
using System.Data;
using System.Collections.Generic;

using Com.Framework.Data;
using Com.Library.DB;

namespace Com.Library.DB.UserCard
{
	internal class UserCardGetInfo : DBDataReader<DataEntity, UserCardEntity>
	{
		public UserCardGetInfo()
			: base(new ConnectionString(), "TSP_UserCard_GetInfo")
		{
		}

		protected override void ParameterInitialize()
		{
			AddParameter("strCardNo", SqlDbType.VarChar, 100, SqlDataInOut.InputOutput);
			AddParameter("n4UserCardNo", SqlDbType.Int, 4, SqlDataInOut.InputOutput);
			AddParameter("n4UserNo", SqlDbType.Int, 4, SqlDataInOut.Output);
			AddParameter("CodeStatus", SqlDbType.TinyInt, 1, SqlDataInOut.Output);
			AddParameter("dtCreateDate", SqlDbType.DateTime, 8, SqlDataInOut.Output);
			AddParameter("dtModifyDate", SqlDbType.DateTime, 8, SqlDataInOut.Output);
			AddParameter("dtRemoveDate", SqlDbType.DateTime, 8, SqlDataInOut.Output);
			AddParameter("strModifyManagerName", SqlDbType.NVarChar, 100, SqlDataInOut.Output);
			AddParameter("strDesc", SqlDbType.NVarChar, 1000, SqlDataInOut.Output);
		}
	}
}